通用电气公司（General Electric Company，简称GE），是世界上最大的提供技术和服务业务的跨国公司。通过自己的不懈努力，成为了GE的一名数据分析实习生，借博客这个平台记录自己的实习过程，希望不仅可以帮助他人，也可以总结自己，获得更大的提升。这篇博客主要讲解实习过程中为Module WS.xlsx文件录入数据的详细细节，以及在DSS学习中学到的Acronyms。
数据填写规则
- WS Validation列
原有45台 ESN（Electronic Serial Number，电子序列号），在WorkScope中查看每台ESN的pdf文件，在GE的EWT网址中搜索ESN号，点击Generate Customer Report 生成的便是该ESN的pdf文件。填写WS Validation列，填写的规则是：
1.没有的模块填写NA
2.HMU模块，根据查找到的description，填写的是Visual Inspection 或 Visually Inspect
3.M15-17 Fan Case模块，pdf中的M15 Fan Case等同于该模块，pdf中的Fan-Stator M17 level 则在WS Validation列填入Fan-Stator M17 I 等
4.M23、M24、M31、M32模块属于M40模块，若有level值则填入对应的level值，若没有level值或M23、M24、M31、M32模块，则在WS Validation 列填入NA.M40 II(ESN中M40模块的level值) - Sub Module WS列和WS Validation列
新加18台ESN，在WorkScope里查看每台ESN的pdf文件，填写Sub Module WS列和WS Validation列，填写规则是：
1.Sub Module列每个模块，若有对应的level值，则在Sub Module WS列中填入相应的level值（1即为I，2即为II……）
2.Sub Module列的模块，若没有，则Sub Module WS空着，即不填也不写WS
3.若没有HMU模块，则在Sub Module WS中空着，在WS Validation中填入对应的description，例如：Visual Inspection 或 Visually Inspect
4.M23、M24、M31、M32模块属于M40模块，若有level值则填入对应的level值，若没有level值或M23、M24、M31、M32模块，则在WS Validation 列填入NA.M40 II(ESN中M40模块的level值) - Cost level列与Comments列
Cost level列与Comments列的填写规则是：
1.复制整列Sub Module WS列内容至Cost level列，若Sub Module WS为空，则Cost level列填SA
2.Filter出Sub Module列的M10 Engine模块，将Cost level全部改为SA
3.Filter出Sub Module列的M71模块，若Sub Module WS为IV，则Cost level也为IV，若Sub Module WS为其它，则Cost level改为II
4.Filter出Sub Module列的M58模块，查看每个ESN的pdf文件，若M58的Comments为Route TCF to vendor for repair，则将该描述添加进Comments列，且若Sub Module WS为II，则将Cost level改为III - Block列与Part Number列
在GE的TEXL GE MRO Data Collaboration网站上找到新加的18台ESN的.zip文件，下载并解压。Block列与Part Number列的填写规则是：
1.在每个ESN的.zip文件中找到Configuration Report R00.xlsx文件并打开，例如查到的HPT S1N 的PN号为2084M68G11
2.在该ESN的.zip文件中找到Life Limited Parts Report R00.xlsx文件并打开，查看Description列中的SEAL-INTERSTAGE HPT ROTOR IN对应的PN号（以Input为准），该PN号与Block的对应关系如下表所示：
PN为2505M72P01的，在Block列天上EIS Old，Part Number列标注上2505M72P01，若PN为其它，则在Block列标注PN值对应的Block值即可，Part Number列不标注。（询问Mentor后，Mentor与技术人员沟通后做出的该规定方法）
| PN | Block |
|---|---|
| 2087M322P02 | EIS Old |
| 2087M322P03 | EIS Old |
| 2448M332P01 | EIS New |
| 2505M72P01 | EIS Old |
Block 定义
- HPT Rotor Interstage Seal
| PN | Comment | Scrap rate | hwconf option |
|---|---|---|---|
| 2087M322P02 | old design, not repairable | 100% | Old |
| 2087M322P03 | old design, not repairable | 100% | Old |
| 2448M332P01 | new design, R88DT,repairable | 3% | New |
| 2505M72P01 | new design + change to R65 material, not repairable yet-treat as old | 3% | New |
- EIS, Block 2012, Block 2014, Block 2015 definition
| Block | Definition |
|---|---|
| EIS | At least one of the following is true: HPT S1N: G11 OR G11/G15, HPT S2N: G07 OR G07/G13, TCF Cooling holes = no, OGV<>P, Shroud = P10 OR P16. |
| Block 2012 | All of the following must be true: HPT S1N: G15 and up, HPT S2N: G13 and up, TCF Cooling holes = yes, OGV leaf seal = P, Shroud = P15(or any Combination of the following: Shroud = P17 or Spoolie = Yes or Combustor Inner Liner = G05 or G06 or HPT S1 Blade = P09 as long as Block 2014 or Block 2015 definition is not met) |
| Block 2014 | All of the following must be true: HPT S1N: G15 and up, HPT S2N: G13 and up, TCF Cooling holes = yes, OGV leaf seal = P, Shroud = P15, Spoolie migration fix = yes, HPT S1B = P09, Combustor Inner Liner = G07(or any Combination of the following: Shroud = P17 or Combustor Dome = 2110M68G06 or 2256M54G03 as long as Block 2015 definition is not met) |
| Block 2015 | HPT S1N: G15 and up, HPT S2N: G13 and up, TCF Cooling holes = yes, OGV leaf seal = P, Shroud = P17, Spoolie migration fix = yes, HPT S1B = P09, Combustor Inner Liner = G07, Combustor Dome = 2110M68G06 or 2256M54G03 |
Sub Module
- Fan Rotor
风扇转子 - HMU
Hydro(液压) Mechanical(机械) Unit(组件) - LRU-Boeing
- LRU-Other
- M10 Engine(引擎) Assembly(装配)
- M15-17 Fan Case Aseembly
- M21 FAN BOOSTER (助推器)
- M23 No 1 Bearing Assy
- M24 No 2 Bearing Assy
- M31 Fan Frame Assy
- M32 IGB-3B BRG
Bearing Inlet Gearbox - M33 TGB
Transfer Gearbox - M40 Fan Booster Compressor
- M54 CD
Combuster Diffuser Assy - M55 HPT S1N
High-pressure Stage 1 Nozzle Assy - M56 HPT S2N
High-pressure Stage 2 Nozzle Assy - M57 HPTR
HP Rotor Assy - M58 TCF
Turbine Center Frame Assy - M61 LPTR+S
LP Rotor Stator(定子) Assy
LP: Linear Programming - M63 TRF
Turbine Rear Frame Assy - M64 FMS LP Mid Shaft Assy
- M71 AGB
Accessory Gearbox Assy - MISC
miscellaneous 各式各样的
macroin struction system computer 宏指令系统计算机
minimum instruction set computer 最小指令集计算机
Malaysian International shipping corporation 马来群岛国际海运公司 - Safran
- TEST Cell
Acronyms(首字母缩略词)
| Acronyms | Full Name |
|---|---|
| AWO | Action work-out |
| BB | Black Belt |
| CA | Course Aerosols(气溶胶) |
| BEC | Bangalore(班加罗尔) Engineering（工程） Center (India) |
| CAL | Caledonia(加里多尼亚) Scotland(英格兰) |
| CAS | Corporate(公司) Audit(审计) Staff(人员) |
| CID | Change in Design |
| CLP | Catalog(目录) List Price |
| CMP | Contract(合同) Margin(保证金) Review(审查) |
| CMR | Contribution(贡献) Margin |
| CPM | Customer(客户) Program(项目) Manager(经理) |
| CSA | Customized(定制) Service(服务) Agreement(协议) |
| CTP | Customer Technical Programs(程序) |
| DR | Departure(离境) Record(记录) |
| DSS | Digital(数字) Services(服务) & Solutions(解决) |
| ECR | External(外部) Component(组件) Repair-Non GE Shop |
| EFH | Engine Flight Hour |
| EGT | Exhaust(排放) Gas Temperature |
| EIS | Entry Into Service |
| EPEX | Engineering Project Execution Tool |
| FDM | Fleet Data Management |
| FFP | Firm(坚定的) Fixed(固定的) Price |
| FL | Flight Leg (航班时间) |
| FPLS | Fixed Price Labor(人工) Schedule(计划) |
| GEES | GE Engine Services |
| GRC | Global Research(研究) Center |
| HCE | High-Cost Event |
| ICR | Internal(内部的) Component Repair |
| LCE | Life Cycle Engineering |
| LLP | Life Limited Part |
| LRU | Line Replaceable(可替换的) Unit(单元) |
| LTRA | Long-term Revenue(利润) Accounting(核算) |
| MBTH | Material By the Hour |
| MCPH | Maintenance(维护) Cost Per Hour |
| MCPS | Material Cost Per Set |
| MCRB | Maintenance Cost Review(审查) Board(委员会) |
| MRB | Material Review Board |
| MRO | Maintenance, Repair, Overhaul |
| NPI | New Product Introduction |
| NTE | Not-tO-Exceed(未超过) |
| OCPH | Overhead(间接) Cost Per Hour |
| OM | Operating Margin |
| OVH | Overhaul |
| OWS | On-wing(在翼) Support |
| PO | Purchase(购买) Order(清单) |
| PPR | Platform Product Review |
| PV | Producer(生产者) Value |
| QI | Quarter(季度) Impact(影响) |
| RSP | Revenue(收入) Share(分享) Partner(伙伴) |
| SC | Shop Cost |
| SOP | Standard Operating Procedure(流程) |
| SPA | Services Performance & Analysis |
| T&M | Time and Material Shop Visit |
| TC | True Cost |
| TOW | Time-on-wing |
| USM | Used Serviceable(维修) Material |
| WIP | Work-in-progress 工作正在进行中 |
| CSA | Customized Service Agreement |
| CCU | Cumulative Catch Up 累积追补 |
| SEED | Services Engineering Engine Data |
| EASA | The European Aviation Safety Agency 欧洲航空安全局Electrical Apparatus Service Association 美国电器设备维修协会 |
- SV
Shop Visit
SV : A Shop Visit (typically a full performance restoration) is a term used when an engine has maintenance performed at an internal or external MRO(Maintenance, Repair and Overhaul) facility.
拆下发电机的大修：一个 Shop Visit （通常是完整的性能恢复）是发动机在内部或外部MRO（维护，修理和大修）设施进行维护时使用的术语。